package com.tjbank.cssys.mybatis.sqlbuilder;

import com.tansun.web.framework.dao.SQLBulider;
import java.io.Serializable;
import java.util.Date;

/**
 * IamRoleSqlBuilder
 * 
 * @author PG(Auto Generator)
 * @version V2.0
 */
public class IamRoleSqlBuilder extends SQLBulider<IamRoleSqlBuilder> implements Serializable {
    private static final long serialVersionUID = -161123581321345589L;

    public IamRoleSqlBuilder() {
        _id = this.toString().split("@")[1];
    }

    public IamRoleSqlBuilder andIdEqualTo(String value) {
        return addAndCriterion("ID", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andIdNotEqualTo(String value) {
        return addAndCriterion("ID", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andIdGreaterThan(String value) {
        return addAndCriterion("ID", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andIdGreaterThanOrEqualTo(String value) {
        return addAndCriterion("ID", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andIdLessThan(String value) {
        return addAndCriterion("ID", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andIdLessThanOrEqualTo(String value) {
        return addAndCriterion("ID", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andIdIsNull() {
        return addAndCriterion("ID", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andIdIsNotNull() {
        return addAndCriterion("ID", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andIdLikeBoth(String value) {
        return addAndCriterion("ID", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andIdLikeLeft(String value) {
        return addAndCriterion("ID", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andIdLikeRigth(String value) {
        return addAndCriterion("ID", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andIdNotLikeBoth(String value) {
        return addAndCriterion("ID", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andIdNotLikeLeft(String value) {
        return addAndCriterion("ID", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andIdNotLikeRigth(String value) {
        return addAndCriterion("ID", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orIdEqualTo(String value) {
        return addOrCriterion("ID", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orIdNotEqualTo(String value) {
        return addOrCriterion("ID", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orIdGreaterThan(String value) {
        return addOrCriterion("ID", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orIdGreaterThanOrEqualTo(String value) {
        return addOrCriterion("ID", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orIdLessThan(String value) {
        return addOrCriterion("ID", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orIdLessThanOrEqualTo(String value) {
        return addOrCriterion("ID", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orIdIsNull() {
        return addOrCriterion("ID", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orIdIsNotNull() {
        return addOrCriterion("ID", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orIdLikeBoth(String value) {
        return addOrCriterion("ID", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orIdLikeLeft(String value) {
        return addOrCriterion("ID", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orIdLikeRigth(String value) {
        return addOrCriterion("ID", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orIdNotLikeBoth(String value) {
        return addOrCriterion("ID", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orIdNotLikeLeft(String value) {
        return addOrCriterion("ID", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orIdNotLikeRigth(String value) {
        return addOrCriterion("ID", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderById(boolean isDesc) {
        return addOrderBy("ID", isDesc);
    }

    public IamRoleSqlBuilder andRoleNameEqualTo(String value) {
        return addAndCriterion("ROLE_NAME", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andRoleNameNotEqualTo(String value) {
        return addAndCriterion("ROLE_NAME", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andRoleNameGreaterThan(String value) {
        return addAndCriterion("ROLE_NAME", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andRoleNameGreaterThanOrEqualTo(String value) {
        return addAndCriterion("ROLE_NAME", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andRoleNameLessThan(String value) {
        return addAndCriterion("ROLE_NAME", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andRoleNameLessThanOrEqualTo(String value) {
        return addAndCriterion("ROLE_NAME", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andRoleNameIsNull() {
        return addAndCriterion("ROLE_NAME", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andRoleNameIsNotNull() {
        return addAndCriterion("ROLE_NAME", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andRoleNameLikeBoth(String value) {
        return addAndCriterion("ROLE_NAME", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andRoleNameLikeLeft(String value) {
        return addAndCriterion("ROLE_NAME", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andRoleNameLikeRigth(String value) {
        return addAndCriterion("ROLE_NAME", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andRoleNameNotLikeBoth(String value) {
        return addAndCriterion("ROLE_NAME", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andRoleNameNotLikeLeft(String value) {
        return addAndCriterion("ROLE_NAME", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andRoleNameNotLikeRigth(String value) {
        return addAndCriterion("ROLE_NAME", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orRoleNameEqualTo(String value) {
        return addOrCriterion("ROLE_NAME", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orRoleNameNotEqualTo(String value) {
        return addOrCriterion("ROLE_NAME", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orRoleNameGreaterThan(String value) {
        return addOrCriterion("ROLE_NAME", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orRoleNameGreaterThanOrEqualTo(String value) {
        return addOrCriterion("ROLE_NAME", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orRoleNameLessThan(String value) {
        return addOrCriterion("ROLE_NAME", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orRoleNameLessThanOrEqualTo(String value) {
        return addOrCriterion("ROLE_NAME", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orRoleNameIsNull() {
        return addOrCriterion("ROLE_NAME", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orRoleNameIsNotNull() {
        return addOrCriterion("ROLE_NAME", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orRoleNameLikeBoth(String value) {
        return addOrCriterion("ROLE_NAME", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orRoleNameLikeLeft(String value) {
        return addOrCriterion("ROLE_NAME", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orRoleNameLikeRigth(String value) {
        return addOrCriterion("ROLE_NAME", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orRoleNameNotLikeBoth(String value) {
        return addOrCriterion("ROLE_NAME", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orRoleNameNotLikeLeft(String value) {
        return addOrCriterion("ROLE_NAME", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orRoleNameNotLikeRigth(String value) {
        return addOrCriterion("ROLE_NAME", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderByRoleName(boolean isDesc) {
        return addOrderBy("ROLE_NAME", isDesc);
    }

    public IamRoleSqlBuilder andRoleAliasEqualTo(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andRoleAliasNotEqualTo(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andRoleAliasGreaterThan(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andRoleAliasGreaterThanOrEqualTo(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andRoleAliasLessThan(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andRoleAliasLessThanOrEqualTo(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andRoleAliasIsNull() {
        return addAndCriterion("ROLE_ALIAS", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andRoleAliasIsNotNull() {
        return addAndCriterion("ROLE_ALIAS", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andRoleAliasLikeBoth(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andRoleAliasLikeLeft(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andRoleAliasLikeRigth(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andRoleAliasNotLikeBoth(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andRoleAliasNotLikeLeft(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andRoleAliasNotLikeRigth(String value) {
        return addAndCriterion("ROLE_ALIAS", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orRoleAliasEqualTo(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orRoleAliasNotEqualTo(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orRoleAliasGreaterThan(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orRoleAliasGreaterThanOrEqualTo(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orRoleAliasLessThan(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orRoleAliasLessThanOrEqualTo(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orRoleAliasIsNull() {
        return addOrCriterion("ROLE_ALIAS", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orRoleAliasIsNotNull() {
        return addOrCriterion("ROLE_ALIAS", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orRoleAliasLikeBoth(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orRoleAliasLikeLeft(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orRoleAliasLikeRigth(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orRoleAliasNotLikeBoth(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orRoleAliasNotLikeLeft(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orRoleAliasNotLikeRigth(String value) {
        return addOrCriterion("ROLE_ALIAS", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderByRoleAlias(boolean isDesc) {
        return addOrderBy("ROLE_ALIAS", isDesc);
    }

    public IamRoleSqlBuilder andTenantCodeEqualTo(String value) {
        return addAndCriterion("TENANT_CODE", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andTenantCodeNotEqualTo(String value) {
        return addAndCriterion("TENANT_CODE", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andTenantCodeGreaterThan(String value) {
        return addAndCriterion("TENANT_CODE", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andTenantCodeGreaterThanOrEqualTo(String value) {
        return addAndCriterion("TENANT_CODE", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andTenantCodeLessThan(String value) {
        return addAndCriterion("TENANT_CODE", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andTenantCodeLessThanOrEqualTo(String value) {
        return addAndCriterion("TENANT_CODE", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andTenantCodeIsNull() {
        return addAndCriterion("TENANT_CODE", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andTenantCodeIsNotNull() {
        return addAndCriterion("TENANT_CODE", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andTenantCodeLikeBoth(String value) {
        return addAndCriterion("TENANT_CODE", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andTenantCodeLikeLeft(String value) {
        return addAndCriterion("TENANT_CODE", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andTenantCodeLikeRigth(String value) {
        return addAndCriterion("TENANT_CODE", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andTenantCodeNotLikeBoth(String value) {
        return addAndCriterion("TENANT_CODE", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andTenantCodeNotLikeLeft(String value) {
        return addAndCriterion("TENANT_CODE", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andTenantCodeNotLikeRigth(String value) {
        return addAndCriterion("TENANT_CODE", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orTenantCodeEqualTo(String value) {
        return addOrCriterion("TENANT_CODE", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orTenantCodeNotEqualTo(String value) {
        return addOrCriterion("TENANT_CODE", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orTenantCodeGreaterThan(String value) {
        return addOrCriterion("TENANT_CODE", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orTenantCodeGreaterThanOrEqualTo(String value) {
        return addOrCriterion("TENANT_CODE", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orTenantCodeLessThan(String value) {
        return addOrCriterion("TENANT_CODE", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orTenantCodeLessThanOrEqualTo(String value) {
        return addOrCriterion("TENANT_CODE", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orTenantCodeIsNull() {
        return addOrCriterion("TENANT_CODE", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orTenantCodeIsNotNull() {
        return addOrCriterion("TENANT_CODE", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orTenantCodeLikeBoth(String value) {
        return addOrCriterion("TENANT_CODE", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orTenantCodeLikeLeft(String value) {
        return addOrCriterion("TENANT_CODE", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orTenantCodeLikeRigth(String value) {
        return addOrCriterion("TENANT_CODE", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orTenantCodeNotLikeBoth(String value) {
        return addOrCriterion("TENANT_CODE", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orTenantCodeNotLikeLeft(String value) {
        return addOrCriterion("TENANT_CODE", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orTenantCodeNotLikeRigth(String value) {
        return addOrCriterion("TENANT_CODE", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderByTenantCode(boolean isDesc) {
        return addOrderBy("TENANT_CODE", isDesc);
    }

    public IamRoleSqlBuilder andTenantNameEqualTo(String value) {
        return addAndCriterion("TENANT_NAME", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andTenantNameNotEqualTo(String value) {
        return addAndCriterion("TENANT_NAME", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andTenantNameGreaterThan(String value) {
        return addAndCriterion("TENANT_NAME", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andTenantNameGreaterThanOrEqualTo(String value) {
        return addAndCriterion("TENANT_NAME", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andTenantNameLessThan(String value) {
        return addAndCriterion("TENANT_NAME", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andTenantNameLessThanOrEqualTo(String value) {
        return addAndCriterion("TENANT_NAME", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andTenantNameIsNull() {
        return addAndCriterion("TENANT_NAME", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andTenantNameIsNotNull() {
        return addAndCriterion("TENANT_NAME", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andTenantNameLikeBoth(String value) {
        return addAndCriterion("TENANT_NAME", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andTenantNameLikeLeft(String value) {
        return addAndCriterion("TENANT_NAME", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andTenantNameLikeRigth(String value) {
        return addAndCriterion("TENANT_NAME", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andTenantNameNotLikeBoth(String value) {
        return addAndCriterion("TENANT_NAME", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andTenantNameNotLikeLeft(String value) {
        return addAndCriterion("TENANT_NAME", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andTenantNameNotLikeRigth(String value) {
        return addAndCriterion("TENANT_NAME", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orTenantNameEqualTo(String value) {
        return addOrCriterion("TENANT_NAME", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orTenantNameNotEqualTo(String value) {
        return addOrCriterion("TENANT_NAME", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orTenantNameGreaterThan(String value) {
        return addOrCriterion("TENANT_NAME", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orTenantNameGreaterThanOrEqualTo(String value) {
        return addOrCriterion("TENANT_NAME", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orTenantNameLessThan(String value) {
        return addOrCriterion("TENANT_NAME", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orTenantNameLessThanOrEqualTo(String value) {
        return addOrCriterion("TENANT_NAME", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orTenantNameIsNull() {
        return addOrCriterion("TENANT_NAME", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orTenantNameIsNotNull() {
        return addOrCriterion("TENANT_NAME", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orTenantNameLikeBoth(String value) {
        return addOrCriterion("TENANT_NAME", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orTenantNameLikeLeft(String value) {
        return addOrCriterion("TENANT_NAME", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orTenantNameLikeRigth(String value) {
        return addOrCriterion("TENANT_NAME", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orTenantNameNotLikeBoth(String value) {
        return addOrCriterion("TENANT_NAME", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orTenantNameNotLikeLeft(String value) {
        return addOrCriterion("TENANT_NAME", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orTenantNameNotLikeRigth(String value) {
        return addOrCriterion("TENANT_NAME", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderByTenantName(boolean isDesc) {
        return addOrderBy("TENANT_NAME", isDesc);
    }

    public IamRoleSqlBuilder andCreateUserEqualTo(String value) {
        return addAndCriterion("CREATE_USER", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andCreateUserNotEqualTo(String value) {
        return addAndCriterion("CREATE_USER", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andCreateUserGreaterThan(String value) {
        return addAndCriterion("CREATE_USER", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andCreateUserGreaterThanOrEqualTo(String value) {
        return addAndCriterion("CREATE_USER", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andCreateUserLessThan(String value) {
        return addAndCriterion("CREATE_USER", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andCreateUserLessThanOrEqualTo(String value) {
        return addAndCriterion("CREATE_USER", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andCreateUserIsNull() {
        return addAndCriterion("CREATE_USER", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andCreateUserIsNotNull() {
        return addAndCriterion("CREATE_USER", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andCreateUserLikeBoth(String value) {
        return addAndCriterion("CREATE_USER", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andCreateUserLikeLeft(String value) {
        return addAndCriterion("CREATE_USER", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andCreateUserLikeRigth(String value) {
        return addAndCriterion("CREATE_USER", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andCreateUserNotLikeBoth(String value) {
        return addAndCriterion("CREATE_USER", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andCreateUserNotLikeLeft(String value) {
        return addAndCriterion("CREATE_USER", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andCreateUserNotLikeRigth(String value) {
        return addAndCriterion("CREATE_USER", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orCreateUserEqualTo(String value) {
        return addOrCriterion("CREATE_USER", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orCreateUserNotEqualTo(String value) {
        return addOrCriterion("CREATE_USER", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orCreateUserGreaterThan(String value) {
        return addOrCriterion("CREATE_USER", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orCreateUserGreaterThanOrEqualTo(String value) {
        return addOrCriterion("CREATE_USER", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orCreateUserLessThan(String value) {
        return addOrCriterion("CREATE_USER", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orCreateUserLessThanOrEqualTo(String value) {
        return addOrCriterion("CREATE_USER", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orCreateUserIsNull() {
        return addOrCriterion("CREATE_USER", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orCreateUserIsNotNull() {
        return addOrCriterion("CREATE_USER", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orCreateUserLikeBoth(String value) {
        return addOrCriterion("CREATE_USER", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orCreateUserLikeLeft(String value) {
        return addOrCriterion("CREATE_USER", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orCreateUserLikeRigth(String value) {
        return addOrCriterion("CREATE_USER", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orCreateUserNotLikeBoth(String value) {
        return addOrCriterion("CREATE_USER", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orCreateUserNotLikeLeft(String value) {
        return addOrCriterion("CREATE_USER", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orCreateUserNotLikeRigth(String value) {
        return addOrCriterion("CREATE_USER", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderByCreateUser(boolean isDesc) {
        return addOrderBy("CREATE_USER", isDesc);
    }

    public IamRoleSqlBuilder andUpdateUserEqualTo(String value) {
        return addAndCriterion("UPDATE_USER", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andUpdateUserNotEqualTo(String value) {
        return addAndCriterion("UPDATE_USER", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andUpdateUserGreaterThan(String value) {
        return addAndCriterion("UPDATE_USER", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andUpdateUserGreaterThanOrEqualTo(String value) {
        return addAndCriterion("UPDATE_USER", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andUpdateUserLessThan(String value) {
        return addAndCriterion("UPDATE_USER", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andUpdateUserLessThanOrEqualTo(String value) {
        return addAndCriterion("UPDATE_USER", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andUpdateUserIsNull() {
        return addAndCriterion("UPDATE_USER", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andUpdateUserIsNotNull() {
        return addAndCriterion("UPDATE_USER", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andUpdateUserLikeBoth(String value) {
        return addAndCriterion("UPDATE_USER", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andUpdateUserLikeLeft(String value) {
        return addAndCriterion("UPDATE_USER", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andUpdateUserLikeRigth(String value) {
        return addAndCriterion("UPDATE_USER", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andUpdateUserNotLikeBoth(String value) {
        return addAndCriterion("UPDATE_USER", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andUpdateUserNotLikeLeft(String value) {
        return addAndCriterion("UPDATE_USER", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andUpdateUserNotLikeRigth(String value) {
        return addAndCriterion("UPDATE_USER", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orUpdateUserEqualTo(String value) {
        return addOrCriterion("UPDATE_USER", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orUpdateUserNotEqualTo(String value) {
        return addOrCriterion("UPDATE_USER", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orUpdateUserGreaterThan(String value) {
        return addOrCriterion("UPDATE_USER", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orUpdateUserGreaterThanOrEqualTo(String value) {
        return addOrCriterion("UPDATE_USER", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orUpdateUserLessThan(String value) {
        return addOrCriterion("UPDATE_USER", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orUpdateUserLessThanOrEqualTo(String value) {
        return addOrCriterion("UPDATE_USER", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orUpdateUserIsNull() {
        return addOrCriterion("UPDATE_USER", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orUpdateUserIsNotNull() {
        return addOrCriterion("UPDATE_USER", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orUpdateUserLikeBoth(String value) {
        return addOrCriterion("UPDATE_USER", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orUpdateUserLikeLeft(String value) {
        return addOrCriterion("UPDATE_USER", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orUpdateUserLikeRigth(String value) {
        return addOrCriterion("UPDATE_USER", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orUpdateUserNotLikeBoth(String value) {
        return addOrCriterion("UPDATE_USER", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orUpdateUserNotLikeLeft(String value) {
        return addOrCriterion("UPDATE_USER", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orUpdateUserNotLikeRigth(String value) {
        return addOrCriterion("UPDATE_USER", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderByUpdateUser(boolean isDesc) {
        return addOrderBy("UPDATE_USER", isDesc);
    }

    public IamRoleSqlBuilder andCreateTimeEqualTo(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andCreateTimeNotEqualTo(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andCreateTimeGreaterThan(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andCreateTimeGreaterThanOrEqualTo(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andCreateTimeLessThan(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andCreateTimeLessThanOrEqualTo(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andCreateTimeIsNull() {
        return addAndCriterion("CREATE_TIME", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andCreateTimeIsNotNull() {
        return addAndCriterion("CREATE_TIME", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andCreateTimeLikeBoth(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andCreateTimeLikeLeft(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andCreateTimeLikeRigth(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andCreateTimeNotLikeBoth(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andCreateTimeNotLikeLeft(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andCreateTimeNotLikeRigth(Date value) {
        return addAndCriterion("CREATE_TIME", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orCreateTimeEqualTo(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orCreateTimeNotEqualTo(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orCreateTimeGreaterThan(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orCreateTimeGreaterThanOrEqualTo(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orCreateTimeLessThan(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orCreateTimeLessThanOrEqualTo(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orCreateTimeIsNull() {
        return addOrCriterion("CREATE_TIME", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orCreateTimeIsNotNull() {
        return addOrCriterion("CREATE_TIME", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orCreateTimeLikeBoth(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orCreateTimeLikeLeft(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orCreateTimeLikeRigth(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orCreateTimeNotLikeBoth(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orCreateTimeNotLikeLeft(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orCreateTimeNotLikeRigth(Date value) {
        return addOrCriterion("CREATE_TIME", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderByCreateTime(boolean isDesc) {
        return addOrderBy("CREATE_TIME", isDesc);
    }

    public IamRoleSqlBuilder andUpdateTimeEqualTo(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andUpdateTimeNotEqualTo(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andUpdateTimeGreaterThan(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andUpdateTimeGreaterThanOrEqualTo(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andUpdateTimeLessThan(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andUpdateTimeLessThanOrEqualTo(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andUpdateTimeIsNull() {
        return addAndCriterion("UPDATE_TIME", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andUpdateTimeIsNotNull() {
        return addAndCriterion("UPDATE_TIME", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andUpdateTimeLikeBoth(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andUpdateTimeLikeLeft(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andUpdateTimeLikeRigth(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andUpdateTimeNotLikeBoth(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andUpdateTimeNotLikeLeft(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andUpdateTimeNotLikeRigth(Date value) {
        return addAndCriterion("UPDATE_TIME", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orUpdateTimeEqualTo(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orUpdateTimeNotEqualTo(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orUpdateTimeGreaterThan(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orUpdateTimeGreaterThanOrEqualTo(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orUpdateTimeLessThan(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orUpdateTimeLessThanOrEqualTo(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orUpdateTimeIsNull() {
        return addOrCriterion("UPDATE_TIME", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orUpdateTimeIsNotNull() {
        return addOrCriterion("UPDATE_TIME", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orUpdateTimeLikeBoth(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orUpdateTimeLikeLeft(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orUpdateTimeLikeRigth(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orUpdateTimeNotLikeBoth(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orUpdateTimeNotLikeLeft(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orUpdateTimeNotLikeRigth(Date value) {
        return addOrCriterion("UPDATE_TIME", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderByUpdateTime(boolean isDesc) {
        return addOrderBy("UPDATE_TIME", isDesc);
    }

    public IamRoleSqlBuilder andStateEqualTo(String value) {
        return addAndCriterion("STATE", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andStateNotEqualTo(String value) {
        return addAndCriterion("STATE", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andStateGreaterThan(String value) {
        return addAndCriterion("STATE", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andStateGreaterThanOrEqualTo(String value) {
        return addAndCriterion("STATE", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andStateLessThan(String value) {
        return addAndCriterion("STATE", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andStateLessThanOrEqualTo(String value) {
        return addAndCriterion("STATE", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andStateIsNull() {
        return addAndCriterion("STATE", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andStateIsNotNull() {
        return addAndCriterion("STATE", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andStateLikeBoth(String value) {
        return addAndCriterion("STATE", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andStateLikeLeft(String value) {
        return addAndCriterion("STATE", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andStateLikeRigth(String value) {
        return addAndCriterion("STATE", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andStateNotLikeBoth(String value) {
        return addAndCriterion("STATE", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andStateNotLikeLeft(String value) {
        return addAndCriterion("STATE", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andStateNotLikeRigth(String value) {
        return addAndCriterion("STATE", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orStateEqualTo(String value) {
        return addOrCriterion("STATE", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orStateNotEqualTo(String value) {
        return addOrCriterion("STATE", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orStateGreaterThan(String value) {
        return addOrCriterion("STATE", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orStateGreaterThanOrEqualTo(String value) {
        return addOrCriterion("STATE", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orStateLessThan(String value) {
        return addOrCriterion("STATE", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orStateLessThanOrEqualTo(String value) {
        return addOrCriterion("STATE", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orStateIsNull() {
        return addOrCriterion("STATE", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orStateIsNotNull() {
        return addOrCriterion("STATE", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orStateLikeBoth(String value) {
        return addOrCriterion("STATE", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orStateLikeLeft(String value) {
        return addOrCriterion("STATE", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orStateLikeRigth(String value) {
        return addOrCriterion("STATE", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orStateNotLikeBoth(String value) {
        return addOrCriterion("STATE", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orStateNotLikeLeft(String value) {
        return addOrCriterion("STATE", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orStateNotLikeRigth(String value) {
        return addOrCriterion("STATE", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderByState(boolean isDesc) {
        return addOrderBy("STATE", isDesc);
    }

    public IamRoleSqlBuilder andIsDeletedEqualTo(String value) {
        return addAndCriterion("IS_DELETED", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder andIsDeletedNotEqualTo(String value) {
        return addAndCriterion("IS_DELETED", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder andIsDeletedGreaterThan(String value) {
        return addAndCriterion("IS_DELETED", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder andIsDeletedGreaterThanOrEqualTo(String value) {
        return addAndCriterion("IS_DELETED", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andIsDeletedLessThan(String value) {
        return addAndCriterion("IS_DELETED", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder andIsDeletedLessThanOrEqualTo(String value) {
        return addAndCriterion("IS_DELETED", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder andIsDeletedIsNull() {
        return addAndCriterion("IS_DELETED", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder andIsDeletedIsNotNull() {
        return addAndCriterion("IS_DELETED", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder andIsDeletedLikeBoth(String value) {
        return addAndCriterion("IS_DELETED", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andIsDeletedLikeLeft(String value) {
        return addAndCriterion("IS_DELETED", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder andIsDeletedLikeRigth(String value) {
        return addAndCriterion("IS_DELETED", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder andIsDeletedNotLikeBoth(String value) {
        return addAndCriterion("IS_DELETED", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder andIsDeletedNotLikeLeft(String value) {
        return addAndCriterion("IS_DELETED", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder andIsDeletedNotLikeRigth(String value) {
        return addAndCriterion("IS_DELETED", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orIsDeletedEqualTo(String value) {
        return addOrCriterion("IS_DELETED", Operator.EqualTo, value);
    }

    public IamRoleSqlBuilder orIsDeletedNotEqualTo(String value) {
        return addOrCriterion("IS_DELETED", Operator.NotEqualTo, value);
    }

    public IamRoleSqlBuilder orIsDeletedGreaterThan(String value) {
        return addOrCriterion("IS_DELETED", Operator.GreaterThan, value);
    }

    public IamRoleSqlBuilder orIsDeletedGreaterThanOrEqualTo(String value) {
        return addOrCriterion("IS_DELETED", Operator.GreaterThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orIsDeletedLessThan(String value) {
        return addOrCriterion("IS_DELETED", Operator.LessThan, value);
    }

    public IamRoleSqlBuilder orIsDeletedLessThanOrEqualTo(String value) {
        return addOrCriterion("IS_DELETED", Operator.LessThanOrEqualTo, value);
    }

    public IamRoleSqlBuilder orIsDeletedIsNull() {
        return addOrCriterion("IS_DELETED", Operator.IsNull, null);
    }

    public IamRoleSqlBuilder orIsDeletedIsNotNull() {
        return addOrCriterion("IS_DELETED", Operator.IsNotNull, null);
    }

    public IamRoleSqlBuilder orIsDeletedLikeBoth(String value) {
        return addOrCriterion("IS_DELETED", Operator.Like, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orIsDeletedLikeLeft(String value) {
        return addOrCriterion("IS_DELETED", Operator.Like, likeMark + value);
    }

    public IamRoleSqlBuilder orIsDeletedLikeRigth(String value) {
        return addOrCriterion("IS_DELETED", Operator.Like, value + likeMark);
    }

    public IamRoleSqlBuilder orIsDeletedNotLikeBoth(String value) {
        return addOrCriterion("IS_DELETED", Operator.NotLike, likeMark + value + likeMark);
    }

    public IamRoleSqlBuilder orIsDeletedNotLikeLeft(String value) {
        return addOrCriterion("IS_DELETED", Operator.NotLike, likeMark + value);
    }

    public IamRoleSqlBuilder orIsDeletedNotLikeRigth(String value) {
        return addOrCriterion("IS_DELETED", Operator.NotLike, value + likeMark);
    }

    public IamRoleSqlBuilder orderByIsDeleted(boolean isDesc) {
        return addOrderBy("IS_DELETED", isDesc);
    }
}